| ColumnName |
Domain |
Datatype |
NULL |
Definition |
| Build |
|
int |
NO |
Application build version. |
| TouchedBy |
|
varchar(50) |
NO |
User ID of the person who is updating the data. |
| TouchedWhenUTC |
|
datetimeoffset(3) |
NO |
Data and time when the data was updated / modified. |
| CreatedBy |
|
varchar(50) |
NO |
User ID of the person who is inserting the data. |
| CreatedWhenUTC |
|
datetimeoffset(3) |
NO |
Data and time when the data was inserted / added. |
| MSRowVersion |
|
timestamp |
NO |
Optimistic lock identifier. |
| MSReplrowguid |
|
uniqueidentifier |
NO |
MSReplrowguid |
ExchangeDocumentEventId |
|
bigint |
NO |
Primary Key for table (used as correlation id in other status tables) |
UserGuid |
|
HVCIDdt |
YES |
Primary Key for CV3User |
| ClientGuid |
|
HVCIDdt |
YES |
Primary Key for CV3Client |
| ClientVisitGuid |
|
HVCIDdt |
YES |
Primary Key for CV3ClientVisit |
| PatientCareDocumentGUID |
|
HVCIDdt |
YES |
Primary Key for CV3PatientCareDocument |
| ClientDocumentGUID |
|
HVCIDdt |
YES |
Primary Key for CV3ClientDocument |
| SourceId |
|
bigint |
YES |
Primary Key of the Task if initiated by the Export Job Execution Service |
| DocContinuityOfCareId |
|
bigint |
YES |
Primary Key of the ContinuityOfCare table |
| EventType |
|
int |
NO |
Type of Event (Generate, Receive, SaveExternal, SearchExternal) |
| StateType |
|
int |
NO |
State of event (Unknown, Pending, Success or Failure) |
| ContextData |
|
xml |
YES |
Additional context data |
| SourceType |
|
int |
NO |
Identifies the type of workflow generating an exchange document. |